IBM's Db2: Database that can be your Jack of all trades
IBM's Db2 is the most low latency enterprises database which supports for faster realtime as well as supporting low latency transactions …
Starting at $0
View PricingOverview
What is Db2?
DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Reviewer Pros & Cons
Pricing
Db2 on Cloud Lite
$0
Cloud
Db2 on Cloud Standard
$99
Cloud
per month
Db2 Warehouse on Cloud Flex One
$898
Cloud
per month
Entry-level set up fee?
- Setup fee optional
For the latest information on pricing, visithttps://www.ibm.com/products/db2/pricin…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Details
- About
- Integrations
- Competitors
- Tech Details
- FAQs
What is Db2?
IBM Db2 empowers developers, DBAs, and enterprise architects to run low-latency transactions and real-time analytics equipped for the most demanding workloads.
From microservices to AI workloads, Db2 is a hybrid database providing availability, built-in refined security, scalability, and intelligent automation for systems.
Availability
Mission critical environments require continuous availability and tolerance for failure. Db2 availability enables users to run workloads without interruption.
Built-in security
Db2 protects data with in-motion and at-rest encryption, auditing, data masking, row and column access controls, and role-based access.
Scalability
Db2 grows with users, scaling up and out as workloads evolve and performance needs change.
Automation
Built-in container operators automate time-consuming database tasks, while keeping the business running. Users can build apps while using Db2's advanced workload management automation and ML-optimized query engine.
Db2 can be run in the cloud, on-premises, or in hybrid environments.
Free Trials available here: https://ibm.biz/BdSWMA
Db2 Integrations
Db2 Competitors
Db2 Technical Details
| Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Windows, Linux, UNIX |
| Mobile Application | No |
Frequently Asked Questions
DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.
Reviewers rate Performance highest, with a score of 9.1.
The most common users of Db2 are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(207)Attribute Ratings
Reviews
(1-10 of 10)Companies can't remove reviews or game the system. Here's why
February 15, 2024
Db2 an Efficient DB Scale and Management Platform!
When we initially looked at Db2 the use case to drive adoption was geared towards control of large scale unstructured data which was sourced from many different sources integration methods. From that initial scope, you can image the workload and compute problems that you have in just extracting, loading, and running data quality processes on that data even before beginning to start to refine and curate for many different presentation layers. Db2 offers a wide range of integration support, has the agility to handle large scale enterprise workloads, and most import offers the flexibility of cloud compatibility.
- Query optimization capabilities - algorithms drive analysis and optimization execution plans for basic to complicated complex queries
- Security built with data design in mind - encryption, access controls, and auditing are fully baked in ready to use amongst many other security features
- Disaster recovery and availability - replication, automatic failover, and failure secondary copy mode for critical workloads and increased uptime
- Learning curve for DB resources - Improvements to UI or native command line built-ins can help with increasing efficiencies for DB resources
- Better resource utilization monitoring and recommendations
- Continue to adopt support for modern frameworks and languages making it easier for organizations to see making Db2 the easy first choice
February 13, 2024
Db2 Review
Db2 has been a critical component of our organization's data management strategy, delivering several advantages to satisfy our business needs. It helps us to achieve our goals. One of the main advantages of Db2 is its dependability, which has continuously supplied us with secure and rapid access to our data.
- Ideal for storing and organizing our client's data
- Compatibility with many systems makes integration smooth
- Processing of queries happens in milliseconds
- The software upgrade process is quite hectic and lengthy
- Rest is all good as per my experience while using it
February 12, 2024
Reliable database platform with good support.
DB2 is used as RDBMS for transactional and reporting applications. We have built a custom application using DB2, and it is also used for reporting and analytics purposes.
- Reporting and analytics.
- Data storage.
- Data retrieval.
- Search speed needs to be improved; it's quite slow.
- Overall, this product has nifty features that work seamlessly with top-of-the-line technology.
- Storing blobs.
February 07, 2024
DB2 review.
DB2 helps design, store, and handle large collections of data. DB2 provides both on-premises and cloud hosting solutions. DB2 can be fine-tuned to scale according to the load, improving performance. DB2 can handle structured, unstructured, and relational data on one platform itself.
- Availability
- Flexible scaling.
- Security
- UI functionality.
- The cost is high.
- Complicated queries.
February 07, 2024
Db2 for enterprise scaling.
Db2 is an object-relational database. It supports database servers; it also extends to support object–relational features and non-relational structures like JSON and XML. It provides high availability and helps with zero downtime and no data loss. It also aids in data partitioning by indexing and delivering optimal performance since it has data governance in Unity catalogs in Data Lakehouse.
- Data Governance.
- High availability disaster recovery.
- Data replication.
- Data partitioning can be optimized with better partition algorithms.
February 07, 2024
Driving API Excellence: Exploring the Dynamic Capabilities of IBM Db2 in Empowering Scalable and Resilient Backend Databases
Our organization use IBM Db2 to leverages its features such as Performance Optimization, backup and recovery, and resource management to ensure the reliability, scalability and performance of our backend used for demanding API-driven applications. It also plays a crucial role in making sure data integrity, security and compliance with regulatory requirements.
- High Availability Disaster Recovery
- Scalability
- Real-time Data Processing
- Open Source Initiatives
- Automated performance tuning
- Simple configuration
January 31, 2024
Hello
Use case in organisation is managing data efficiently and security.
The business problem is the big data and this really helps in making it concise and presentable format which is really good in handling clients. The scope of use case actually very it is useful in case of some small case industries, large enterprise systems which eventually leads to using in a lot of varieties of industries.
- Ensuring reliability
- Security
- Concise and presentable data
- AI based features
- Auto suggestions
- Faster results
December 11, 2023
Why use IBM DB2?
I'm a fan of IBM technology, I'm currently studying systems analysis and development, as I'm studying data science I needed to look for a relational database based on SQL where I could store my data. At the moment I use DB2 for studies so I opted for the DB2 Community license, it is simple and free.
- Storage optimization
- Rapid database development
- pureScale technology, which focuses the database on availability and scalability
- Simplicity and security when performing migrations
- Ease and flexibility in implementation
- The relational model requires a rigid schema that does not necessarily fit with some types of modern development.
- Proprietary database, requires a lot of Hardware for its good performance and its costs are high.
- As data grows in production environment, it becomes slow.
September 13, 2022
Heavy but lightning fast
We use Db2 and LUW in our environment for almost everything; about a 90/10 split with some form of Db2 vs SQL Server. We use it exclusively for its horsepower, especially on z, leaving the smaller workloads to MsSS. We run our large, demanding OLTP applications on Db2 and it never seems to break a sweat.
- transactional workloads at high volume
- encryption at rest and in flight
- manages large objects LOB/BLOB/XML well
- everything about Db2 is 'heavy', even the Community edition and some of the clients
- difficult to configure for beginners /option overload
- LUW and z platforms have minor inconsistencies that really should be a non-issue
- support seems to be declining in terms of quality/quickness of responses
December 08, 2015
IBM DB2 - love it or leave it - It's binary
We currently use DB2 as one of our major database platforms across the organization in multiple different capacities. We have it in different environments, use it for testing of new software features, and use it to support legacy software. This software addresses the need to support legacy Java with the technology of a robust mainframe.
- DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
- Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
- Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
- Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
- Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.
- You cannot run multiple secondary nodes or cluster without additional software purchases; in some cases third party tools. This drastically increases your overall capital investment. The only way to accomplish a true HADR scenario is to set up NEARSYNC in one datacenter and do logshipping to another datacenter. Downside: You have to wait for the final log ship to complete before your DB is back up.
- Licensing is prohibitively expensive! If you are not grandfathered in, IBM licensing for a multi-datacenter, PRIMARY, SECONDARY, and Disaster Recovery (DR) setup can be in the multiple $100,000 range.
- Data Studio is built on IBM's Rapid Application Development (RAD) tool, built on Eclipse. So the download is in the multi-GB range and it includes a ton of bloatware not needed for your standard database maintenance. Control Center is a simple, powerful tool at a quarter of the disk space.
- Support for DB2 is very hard to come by without paid IBM support. Even then, opening PMRs does not solve problems as the response time for any PMR is always more than two (2) hours, even for enterprise-level paying customers. They always want the most inane log files that have nothing to do with DB2 or its operation, or they want core dumps during the issue. This becomes useless when the issue is "our database just crashed and you can't get those logs right now because I do not want to replicate the cause!"
- DB2's SQL syntax, while ANSI in CRUD opertaions, is different than Oracle. PostgreSQL, MySQL, and even MS SQL. One must become accustomed to a different syntax for LIMITs, cursors, record counting, stored procedures, user-defined functions, and even table / index creation or altering.